package com.chw.shop.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.chw.shop.entity.po.ShopSpecs;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ISpecsDao extends BaseMapper<ShopSpecs> {
    @Select("select b.`value` from commodity_key a LEFT JOIN commodity_value b on a.id=b.aid  where a.nameID=#{k}  and b.valueID=#{v}")
    public List<String> getName(@Param("k") String k, @Param("v") String v);
}
